﻿create procedure [dbo].[usp_Add_And_Update_PublicHolidays] 
@Id as int, 
@HolidayDate as datetime,  
@Description as nvarchar(50)  
as  
if @Id!=0

begin
update TblPublicHolidays set
HolidayDate = @HolidayDate ,
Description = @Description where Id = @Id
end
else
begin  
insert into TblPublicHolidays (HolidayDate,Description) values (@HolidayDate,@Description)
end
